package com.qding.park.manager.pojo.example;

import java.util.ArrayList;
import java.util.List;

import com.alibaba.fastjson.JSONObject;


/**
 * @ClassName: TbCarExample
 * @Description: TbCar 对象的统计查询
 * @author Comsys-Administrator
 * @date 2016年10月9日 下午3:49:31
 *
 */
public class TbCarExample {

	protected String orderByClause;

	protected boolean distinct;

	protected List<Criteria> oredCriteria;
	
	public  TbCarExample(){
		 oredCriteria = new ArrayList<Criteria>();
	}

	public String getOrderByClause() {
		return orderByClause;
	}

	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}
	
	public void orderByCreateTimeDesc(){
		
		this.orderByClause = "qdpk_usercar_releation.Create_date desc";
	}

	public boolean isDistinct() {
		return distinct;
	}

	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}

	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}

	public void setOredCriteria(List<Criteria> oredCriteria) {
		this.oredCriteria = oredCriteria;
	}

	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}

	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}

	public static class Criteria extends GeneratedCriteria {

		protected Criteria() {
			super();
		}
	}

	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;

		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}

		public boolean isValid() {
			return criteria.size() > 0;
		}

		public List<Criterion> getAllCriteria() {
			return criteria;
		}

		public List<Criterion> getCriteria() {
			return criteria;
		}

		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			criteria.add(new Criterion(condition));
		}

		protected void addCriterion(String condition, Object value, String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value));
		}

		protected void addCriterion(String condition, Object value1, Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value1, value2));
		}

		public Criteria andCarnumEqualTo(String value) {
			addCriterion("qdpk_usercar_releation.carNum =", value, "carNum");
//			addCriterion("qdpk_usercar_releation.carNum like ", " '%"+value+"%'", "carNum");
			return (Criteria) this;
		}
		
		
		public Criteria andCarnumLike(String value) {
			String v="CONCAT('%',"+"'"+value+"'"+",'%' )";
			addCriterion("qdpk_usercar_releation.carNum like "+v);
			return (Criteria) this;
		}
		
		public Criteria andTelLike(Object value) {
			String v="CONCAT('%',"+"'"+value+"'"+",'%' )";
			addCriterion("CAST(qdpk_userinfo.tel AS CHAR)  like "+v);
			return (Criteria) this;
		} 
		
		public Criteria andTelEqualTo(String value) {
			addCriterion("qdpk_userinfo.tel =", value, "tel");
			return (Criteria) this;
		} 
		
		public Criteria andCardTypeEqualTo(int value) {
			addCriterion("qdpk_usercar_releation.cardType =", value, "tel");
			return (Criteria) this;
		} 
		
		public Criteria andMonthFee(String value) {
			
			JSONObject  json=JSONObject.parseObject(value);
			long fee=json.getLongValue("fee");
//			if(fee<0){
//				return (Criteria) this;
//			}
			String operation=json.getString("operation");
			
			if(">".equals(operation)){
				addCriterion("qdpk_usercar_releation.monthFee >", fee, "fee");
			}else if("=".equals(operation)){
				addCriterion("qdpk_usercar_releation.monthFee =", fee, "fee");
			}else if("<".equals(operation)){
				addCriterion("qdpk_usercar_releation.monthFee <", fee, "fee");
			}
			
			return (Criteria) this;
		} 
		
		
		public Criteria andParkIdEqualTo(int value) {
			addCriterion("qdpk_usercar_releation.ParkID =", value, "value");
			return (Criteria) this;
		} 
		
		
		public Criteria andStatusEqualTo(int value) {
			addCriterion("qdpk_usercar_releation.Status =", value, "Status");
			return (Criteria) this;
		} 
		
		public Criteria andTelEqualTo(int value) {
			addCriterion("qdpk_usercar_releation.tel =", value, "tel");
			return (Criteria) this;
		} 
		
		
		public Criteria andExpiryStatusEqualTo(int value) {
			if(value==0){
				//未过期
				addCriterion("qdpk_usercar_releation.ExpiredTime > now()");
			}else if(value==1){
				//已过期
				addCriterion("(qdpk_usercar_releation.ExpiredTime is null or qdpk_usercar_releation.ExpiredTime <= now()  )");
			}
			
			return (Criteria) this;
		} 
		
		public Criteria andParkIdIn(List<Integer> parks) {
			addCriterion("qdpk_usercar_releation.ParkID in ", parks, "parks");
			return (Criteria) this;
		} 
		
		public Criteria andStatusNotEqualTo(int value) {
			addCriterion("qdpk_usercar_releation.status !=", value, "status");
			return (Criteria) this;
		}

	}

	public static class Criterion {
		private String condition;

		private Object value;

		private Object secondValue;

		private boolean noValue;

		private boolean singleValue;

		private boolean betweenValue;

		private boolean listValue;

		private String typeHandler;

		public String getCondition() {
			return condition;
		}

		public Object getValue() {
			return value;
		}

		public Object getSecondValue() {
			return secondValue;
		}

		public boolean isNoValue() {
			return noValue;
		}

		public boolean isSingleValue() {
			return singleValue;
		}

		public boolean isBetweenValue() {
			return betweenValue;
		}

		public boolean isListValue() {
			return listValue;
		}

		public String getTypeHandler() {
			return typeHandler;
		}

		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}

		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}

		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}

		protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}

		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}
	}
}
